﻿using System;
using System.Collections.Generic;
using System.Text;

namespace RaisingStudio.Data.Entities.MSPetShop4
{
    public partial class _Supplier : RaisingStudio.Data.Expressions.TableExpression
    {
        #region Constructor (s) / Destructor
        /// <summary>
        /// Constructor (s) / Destructor.
        /// </summary>
        public _Supplier() : base("Supplier")
        {
        }
        #endregion
        #region Members
        public static readonly RaisingStudio.Data.Expressions.ColumnExpression _SuppId = "SuppId";
        public readonly RaisingStudio.Data.Expressions.ColumnExpression SuppId = _SuppId;
        public static readonly RaisingStudio.Data.Expressions.ColumnExpression _Name = "Name";
        public readonly RaisingStudio.Data.Expressions.ColumnExpression Name = _Name;
        public static readonly RaisingStudio.Data.Expressions.ColumnExpression _Status = "Status";
        public readonly RaisingStudio.Data.Expressions.ColumnExpression Status = _Status;
        public static readonly RaisingStudio.Data.Expressions.ColumnExpression _Addr1 = "Addr1";
        public readonly RaisingStudio.Data.Expressions.ColumnExpression Addr1 = _Addr1;
        public static readonly RaisingStudio.Data.Expressions.ColumnExpression _Addr2 = "Addr2";
        public readonly RaisingStudio.Data.Expressions.ColumnExpression Addr2 = _Addr2;
        public static readonly RaisingStudio.Data.Expressions.ColumnExpression _City = "City";
        public readonly RaisingStudio.Data.Expressions.ColumnExpression City = _City;
        public static readonly RaisingStudio.Data.Expressions.ColumnExpression _State = "State";
        public readonly RaisingStudio.Data.Expressions.ColumnExpression State = _State;
        public static readonly RaisingStudio.Data.Expressions.ColumnExpression _Zip = "Zip";
        public readonly RaisingStudio.Data.Expressions.ColumnExpression Zip = _Zip;
        public static readonly RaisingStudio.Data.Expressions.ColumnExpression _Phone = "Phone";
        public readonly RaisingStudio.Data.Expressions.ColumnExpression Phone = _Phone;

		#endregion
    }

    partial class Supplier
    {
        #region Members
        public static readonly _Supplier _ = new _Supplier();

        public static RaisingStudio.Data.Expressions.ConditionExpression All
        {
            get
            {
                return new RaisingStudio.Data.Expressions.ConditionExpression();
            }
        }

        public static RaisingStudio.Data.Expressions.ColumnExpression[] Columns
        {
            get
            {
                return new RaisingStudio.Data.Expressions.ColumnExpression[]
                        {
                            _Supplier._SuppId,
                            _Supplier._Name,
                            _Supplier._Status,
                            _Supplier._Addr1,
                            _Supplier._Addr2,
                            _Supplier._City,
                            _Supplier._State,
                            _Supplier._Zip,
                            _Supplier._Phone,
                        };
            }
        }

        public static RaisingStudio.Data.Expressions.ColumnExpression[] Except(params RaisingStudio.Data.Expressions.ColumnExpression[] columns)
        {
            List<RaisingStudio.Data.Expressions.ColumnExpression> columnList = new List<RaisingStudio.Data.Expressions.ColumnExpression>(Columns);
            if ((columns != null) && (columns.Length > 0))
            {
                foreach (RaisingStudio.Data.Expressions.ColumnExpression column in columns)
                {
                    columnList.Remove(column);
                }
            }
            return columnList.ToArray();
        }
		#endregion
    }
}
